Обзор данных

Dataset statistics

Number of variables	21
Number of observations	8680
Missing cells	13543
Missing cells (%)	7.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	206.4 B

Variable types

Numeric	11
Categorical	10

Alerts

`customer_questions_and_answers` has a high cardinality: 815 distinct values	High cardinality
`customer_reviews` has a high cardinality: 5560 distinct values	High cardinality
`date_reviews` has a high cardinality: 2060 distinct values	High cardinality
`manufacturer` has a high cardinality: 2272 distinct values	High cardinality
`product_description` has a high cardinality: 7863 distinct values	High cardinality
`product_name` has a high cardinality: 8650 distinct values	High cardinality
`sub_category` has a high cardinality: 231 distinct values	High cardinality
`Item_Weight` is highly overall correlated with `Product_Dimensions_X`	High correlation
`Product_Dimensions_X` is highly overall correlated with `Product_Dimensions_Z`	High correlation
`Product_Dimensions_Y` is highly overall correlated with `Product_Dimensions_X`	High correlation
`average_review_rating` is highly overall correlated with `customer_review`	High correlation
`customer_review` is highly overall correlated with `average_review_rating`	High correlation
`df_index` is highly overall correlated with `category`	High correlation
`number_of_reviews` is highly overall correlated with `category`	High correlation
`category` is highly overall correlated with `df_index` and 2 other fields	High correlation
`Product_Dimensions_Z` is highly overall correlated with `Product_Dimensions_X`	High correlation
`MAX_Manufacturer_recommended_age` is highly overall correlated with `category`	High correlation
`Item_Weight` has 1826 (21.0%) missing values	Missing
`MAX_Manufacturer_recommended_age` has 815 (9.4%) missing values	Missing
`number_in_stock` has 2087 (24.0%) missing values	Missing
`number_of_answered_questions` has 646 (7.4%) missing values	Missing
`Product_Dimensions_X` has 2015 (23.2%) missing values	Missing
`Product_Dimensions_Y` has 2015 (23.2%) missing values	Missing
`Product_Dimensions_Z` has 2051 (23.6%) missing values	Missing
`type_product` has 2087 (24.0%) missing values	Missing
`Item_Weight` is highly skewed (γ1 = 70.28420882)	Skewed
`price` is highly skewed (γ1 = 22.25958774)	Skewed
`Product_Dimensions_Y` is highly skewed (γ1 = 75.05608385)	Skewed
`product_name` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`price` has 1205 (13.9%) zeros	Zeros

Reproduction

Analysis started	2022-12-12 11:31:38.943934
Analysis finished	2022-12-12 11:32:01.872850
Duration	22.93 seconds
Software version	pandas-profiling vdev
Download configuration	config.json

average_review_rating
Real number (ℝ)

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7045161

Minimum	2.3
Maximum	5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	2.3
5-th percentile	4
Q1	4.5
median	5
Q3	5
95-th percentile	5
Maximum	5
Range	2.7
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	0.37334309
Coefficient of variation (CV)	0.079358446
Kurtosis	-0.39660473
Mean	4.7045161
Median Absolute Deviation (MAD)	0
Skewness	-0.93320368
Sum	40835.2
Variance	0.13938506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
5	4441	51.2%
4	1138	13.1%
4.5	625	7.2%
4.8	483	5.6%
4.7	464	5.3%
4.3	362	4.2%
4.6	344	4.0%
4.4	262	3.0%
4.9	208	2.4%
4.2	199	2.3%
Other values (9)	154	1.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.3	1	< 0.1%
3	3	< 0.1%
3.3	2	< 0.1%
3.5	2	< 0.1%
3.6	3	< 0.1%
3.7	2	< 0.1%
3.8	1	< 0.1%
3.9	6	0.1%
4	1138	13.1%
4.1	134	1.5%

Value	Count	Frequency (%)
5	4441	51.2%
4.9	208	2.4%
4.8	483	5.6%
4.7	464	5.3%
4.6	344	4.0%
4.5	625	7.2%
4.4	262	3.0%
4.3	362	4.2%
4.2	199	2.3%
4.1	134	1.5%

category
Categorical

Distinct	42
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

Hobbies	1340
Die-Cast & Toy Vehicles	1183
Figures & Playsets	1067
Characters & Brands	907
Games	891
Other values (37)	3292

Length

Max length	32
Median length	25
Mean length	14.932143
Min length	3

Characters and Unicode

Total characters	129611
Distinct characters	51
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.1%

Sample

1st row	Hobbies
2nd row	Hobbies
3rd row	Hobbies
4th row	Hobbies
5th row	Hobbies

Common Values

Value	Count	Frequency (%)
Hobbies	1340	15.4%
Die-Cast & Toy Vehicles	1183	13.6%
Figures & Playsets	1067	12.3%
Characters & Brands	907	10.4%
Games	891	10.3%
Arts & Crafts	736	8.5%
Party Supplies	582	6.7%
Fancy Dress	558	6.4%
Sports Toys & Outdoor	344	4.0%
Dolls & Accessories	315	3.6%
Other values (32)	757	8.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	5209	23.4%
hobbies	1340	6.0%
toy	1201	5.4%
die-cast	1183	5.3%
vehicles	1183	5.3%
figures	1067	4.8%
playsets	1067	4.8%
characters	907	4.1%
brands	907	4.1%
games	891	4.0%
Other values (73)	7313	32.8%

Most occurring characters

Value	Count	Frequency (%)
s	16265	12.5%
	13588	10.5%
e	12229	9.4%
a	8469	6.5%
r	7869	6.1%
t	6811	5.3%
i	6050	4.7%
&	5209	4.0%
o	4819	3.7%
y	4025	3.1%
Other values (41)	44277	34.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91376	70.5%
Uppercase Letter	18242	14.1%
Space Separator	13588	10.5%
Other Punctuation	5222	4.0%
Dash Punctuation	1183	0.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	16265	17.8%
e	12229	13.4%
a	8469	9.3%
r	7869	8.6%
t	6811	7.5%
i	6050	6.6%
o	4819	5.3%
y	4025	4.4%
l	3946	4.3%
c	3347	3.7%
Other values (15)	17546	19.2%

Uppercase Letter

Value	Count	Frequency (%)
C	2835	15.5%
P	2535	13.9%
D	2062	11.3%
T	2020	11.1%
F	1625	8.9%
H	1346	7.4%
V	1183	6.5%
A	1058	5.8%
B	1015	5.6%
S	961	5.3%
Other values (11)	1602	8.8%

Other Punctuation

Value	Count	Frequency (%)
&	5209	99.8%
,	12	0.2%
'	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	13588	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1183	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	109618	84.6%
Common	19993	15.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	16265	14.8%
e	12229	11.2%
a	8469	7.7%
r	7869	7.2%
t	6811	6.2%
i	6050	5.5%
o	4819	4.4%
y	4025	3.7%
l	3946	3.6%
c	3347	3.1%
Other values (36)	35788	32.6%

Common

Value	Count	Frequency (%)
	13588	68.0%
&	5209	26.1%
-	1183	5.9%
,	12	0.1%
'	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	129611	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	16265	12.5%
	13588	10.5%
e	12229	9.4%
a	8469	6.5%
r	7869	6.1%
t	6811	5.3%
i	6050	4.7%
&	5209	4.0%
o	4819	3.7%
y	4025	3.1%
Other values (41)	44277	34.2%

customer_questions_and_answers
Categorical

Distinct	815
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

nan	7864
does it have an inflated bottom No	2
Are these the newest cards out HelloYes they are Thanks Does this include the binder Yes it has the folder to put the cards in Does this include the Binder It comes with a folder containing a4 sheets of card sleeves	2
Does this catalogue detail all the previous Hornby products please HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent years see more HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent yearsHope this helps see less	1
Does anyone know if this pen will be able to both write on glass and be wiped off Thanks Yes you can write on glass with it And it does wipe off easily but leaves a little residue on the glass so you would need to wipe over with something like a microfibre cloth to get it properly clean	1
Other values (810)	810

Length

Max length	7121
Median length	3
Mean length	35.383295
Min length	3

Characters and Unicode

Total characters	307127
Distinct characters	69
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	812 ?
Unique (%)	9.4%

Sample

1st row	Does this catalogue detail all the previous Hornby products please HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent years see more HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent yearsHope this helps see less
2nd row	can you turn off sounds hi no you cant turn sound off
3rd row	What is the gauge of the track Hi PaulTruthfully Im not sure But its very much alike to a 00 gauge But this train set isnt an addon for an electric train set nor has nothing to do with oneI bought this for my 4 year old nephew as he adores trains but is far too young for an electric set He was VERY happy with this though what is the layout of the tracks Its an oval shape layout
4th row	nan
5th row	nan

Common Values

Value	Count	Frequency (%)
nan	7864	90.6%
does it have an inflated bottom No	2	< 0.1%
Are these the newest cards out HelloYes they are Thanks Does this include the binder Yes it has the folder to put the cards in Does this include the Binder It comes with a folder containing a4 sheets of card sleeves	2	< 0.1%
Does this catalogue detail all the previous Hornby products please HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent years see more HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent yearsHope this helps see less	1	< 0.1%
Does anyone know if this pen will be able to both write on glass and be wiped off Thanks Yes you can write on glass with it And it does wipe off easily but leaves a little residue on the glass so you would need to wipe over with something like a microfibre cloth to get it properly clean	1	< 0.1%
Hi Im doing some stenciling on my kitchen wall and I would like to know if they are waterproof and ideal for this kind of work Cheers Graham Hi I have never used them for kitchen walls I only use them for crafts ie cards and scrapbooking I think you would be better using acrylic paint It might fade if using the promakers and it would be a shame after all your hard work stencilling	1	< 0.1%
Does only 1 come A pack of 8 Can you confirm this is a pack of 8 please Yes its a pack of 8 is there any way of washing these off They are water soluble so they will wash off hands and clothing	1	< 0.1%
What colors and Ink types are included Are they set or do they differ fror every order Is there a chence to get more than one pen in the same colour Hi Inta The packs contains 30 different colour gel pens as in the picture 10 x fluorescent gel pens 10 x glitter gel pens and 10 x metallic gel pens Kind Regards Peter These pens work well on the paper in the stained glass windows which is like parchment paper I havent used them in that boom butvyes I think it would be fine Can you use them on parchment craft sheets Hello I am sorry but i dont know whether they are suitable for parchment craft sheets as i have never used them on parchment sheetskind regardsjodey are these suitable for adult colouring books I love them they are great for really fine designs the only thing to be wary of is that they will smudge if you are not careful They dry really quick though and the glitter ones are really fun to use	1	< 0.1%
At what temperature should you set the oven for heatfixing and for how longv Place in pre heated oven At 160 degrees for half an hour Do these pens dry opaque or transparent They dry opaque and hold the colour well Are these good for painting wine glasses with Will the paint set after oven drying and not wash off I put a thin layer on first then repeated until desired effect They look great now Once air dried washed them and theyre fab Hope that helps x could you use these to draw on Cellophane Do they need to be heated to dry no they did not needed to be heated to dry u can just leave it to dry it needs to be heated to dry on cups plates ect to make it permanent I did try drawing on a bit of clingfilm and found it to be like normal felt pens very easy to smudge but on glass and porcelain once dried it doesnt smudge but can wash off in hot see more no they did not needed to be heated to dry u can just leave it to dry it needs to be heated to dry on cups plates ect to make it permanent I did try drawing on a bit of clingfilm and found it to be like normal felt pens very easy to smudge but on glass and porcelain once dried it doesnt smudge but can wash off in hot water if not heat treated hope that helps see less	1	< 0.1%
What are the dimensions of this set Approx 30cm by 45cm I think Can you refill with normal felt tips after existing ones run out Hi Claire not really The plastic inset is sized for the Ryman Pencils for that set We had a set of Hb pencils and they did not fit That aside I would not recommend this product as the case just fell apart in her hands when my 11 year old unwrapped it Christmas morning The hinges came of and 2 of the panels th see more Hi Claire not really The plastic inset is sized for the Ryman Pencils for that set We had a set of Hb pencils and they did not fit That aside I would not recommend this product as the case just fell apart in her hands when my 11 year old unwrapped it Christmas morning The hinges came of and 2 of the panels that made up the bottom tray It looks solid but feels flimsy Rymans refunded but it was disappointing see less	1	< 0.1%
Other values (805)	805	9.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	7864	12.5%
the	2829	4.5%
it	1416	2.3%
is	1302	2.1%
a	1216	1.9%
to	1131	1.8%
and	1089	1.7%
i	1046	1.7%
this	904	1.4%
you	837	1.3%
Other values (5489)	43128	68.7%

Most occurring characters

Value	Count	Frequency (%)
	60398	19.7%
n	28163	9.2%
e	26047	8.5%
a	24411	7.9%
t	20255	6.6%
o	17350	5.6%
s	15261	5.0%
i	14483	4.7%
r	11888	3.9%
h	11577	3.8%
Other values (59)	77294	25.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	235681	76.7%
Space Separator	60400	19.7%
Uppercase Letter	7435	2.4%
Decimal Number	2712	0.9%
Control	862	0.3%
Connector Punctuation	37	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	28163	11.9%
e	26047	11.1%
a	24411	10.4%
t	20255	8.6%
o	17350	7.4%
s	15261	6.5%
i	14483	6.1%
r	11888	5.0%
h	11577	4.9%
l	9603	4.1%
Other values (17)	56643	24.0%

Uppercase Letter

Value	Count	Frequency (%)
I	1686	22.7%
T	794	10.7%
H	725	9.8%
A	404	5.4%
D	390	5.2%
W	380	5.1%
Y	354	4.8%
C	323	4.3%
S	319	4.3%
M	262	3.5%
Other values (17)	1798	24.2%

Decimal Number

Value	Count	Frequency (%)
1	508	18.7%
2	410	15.1%
0	391	14.4%
3	280	10.3%
5	267	9.8%
4	265	9.8%
6	212	7.8%
8	160	5.9%
7	121	4.5%
9	98	3.6%

Space Separator

Value	Count	Frequency (%)
	60398	> 99.9%
	2	< 0.1%

Control

Value	Count	Frequency (%)
	860	99.8%
	2	0.2%

Connector Punctuation

Value	Count	Frequency (%)
_	37	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	243116	79.2%
Common	64011	20.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	28163	11.6%
e	26047	10.7%
a	24411	10.0%
t	20255	8.3%
o	17350	7.1%
s	15261	6.3%
i	14483	6.0%
r	11888	4.9%
h	11577	4.8%
l	9603	3.9%
Other values (44)	64078	26.4%

Common

Value	Count	Frequency (%)
	60398	94.4%
	860	1.3%
1	508	0.8%
2	410	0.6%
0	391	0.6%
3	280	0.4%
5	267	0.4%
4	265	0.4%
6	212	0.3%
8	160	0.2%
Other values (5)	260	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	307119	> 99.9%
None	8	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	60398	19.7%
n	28163	9.2%
e	26047	8.5%
a	24411	7.9%
t	20255	6.6%
o	17350	5.6%
s	15261	5.0%
i	14483	4.7%
r	11888	3.9%
h	11577	3.8%
Other values (56)	77286	25.2%

None

Value	Count	Frequency (%)
Â	5	62.5%
	2	25.0%
è	1	12.5%

customer_review
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

5.0	6499
4.0	1640
3.0	339
2.0	101
1.0	101

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	26040
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.0
2nd row	4.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	6499	74.9%
4.0	1640	18.9%
3.0	339	3.9%
2.0	101	1.2%
1.0	101	1.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	6499	74.9%
4.0	1640	18.9%
3.0	339	3.9%
2.0	101	1.2%
1.0	101	1.2%

Most occurring characters

Value	Count	Frequency (%)
.	8680	33.3%
0	8680	33.3%
5	6499	25.0%
4	1640	6.3%
3	339	1.3%
2	101	0.4%
1	101	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17360	66.7%
Other Punctuation	8680	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	8680	50.0%
5	6499	37.4%
4	1640	9.4%
3	339	2.0%
2	101	0.6%
1	101	0.6%

Other Punctuation

Value	Count	Frequency (%)
.	8680	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	26040	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	8680	33.3%
0	8680	33.3%
5	6499	25.0%
4	1640	6.3%
3	339	1.3%
2	101	0.4%
1	101	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26040	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	8680	33.3%
0	8680	33.3%
5	6499	25.0%
4	1640	6.3%
3	339	1.3%
2	101	0.4%
1	101	0.4%

customer_reviews
Categorical

Distinct	5560
Distinct (%)	64.1%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

Five Stars	1719
Four Stars	286
Great	83
Excellent	59
Perfect	36
Other values (5555)	6497

Length

Max length	128
Median length	119
Mean length	21.190438
Min length	0

Characters and Unicode

Total characters	183933
Distinct characters	65
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5234 ?
Unique (%)	60.3%

Sample

1st row	Worth Buying For The Pictures Alone As Ever
2nd row	Four Stars
3rd row	Highly Recommended
4th row	I love it
5th row	Birthday present

Common Values

Value	Count	Frequency (%)
Five Stars	1719	19.8%
Four Stars	286	3.3%
Great	83	1.0%
Excellent	59	0.7%
Perfect	36	0.4%
Brilliant	35	0.4%
great	27	0.3%
Good	27	0.3%
Three Stars	26	0.3%
good	22	0.3%
Other values (5550)	6360	73.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
stars	2042	6.0%
five	1726	5.1%
great	959	2.8%
the	846	2.5%
a	755	2.2%
good	715	2.1%
for	693	2.0%
and	591	1.7%
it	443	1.3%
to	410	1.2%
Other values (4646)	24693	72.9%

Most occurring characters

Value	Count	Frequency (%)
	25988	14.1%
e	17072	9.3%
t	13773	7.5%
a	12651	6.9%
r	10893	5.9%
o	10670	5.8%
i	10271	5.6%
s	9045	4.9%
l	7444	4.0%
n	7282	4.0%
Other values (55)	58844	32.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	142295	77.4%
Space Separator	25988	14.1%
Uppercase Letter	14791	8.0%
Decimal Number	855	0.5%
Connector Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	17072	12.0%
t	13773	9.7%
a	12651	8.9%
r	10893	7.7%
o	10670	7.5%
i	10271	7.2%
s	9045	6.4%
l	7444	5.2%
n	7282	5.1%
d	5351	3.8%
Other values (17)	37843	26.6%

Uppercase Letter

Value	Count	Frequency (%)
S	2662	18.0%
F	2510	17.0%
G	1227	8.3%
A	795	5.4%
T	759	5.1%
B	650	4.4%
E	603	4.1%
I	602	4.1%
P	545	3.7%
L	486	3.3%
Other values (16)	3952	26.7%

Decimal Number

Value	Count	Frequency (%)
1	189	22.1%
0	161	18.8%
2	110	12.9%
3	89	10.4%
4	66	7.7%
5	57	6.7%
6	49	5.7%
9	47	5.5%
7	44	5.1%
8	43	5.0%

Space Separator

Value	Count	Frequency (%)
	25988	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	157086	85.4%
Common	26847	14.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	17072	10.9%
t	13773	8.8%
a	12651	8.1%
r	10893	6.9%
o	10670	6.8%
i	10271	6.5%
s	9045	5.8%
l	7444	4.7%
n	7282	4.6%
d	5351	3.4%
Other values (43)	52634	33.5%

Common

Value	Count	Frequency (%)
	25988	96.8%
1	189	0.7%
0	161	0.6%
2	110	0.4%
3	89	0.3%
4	66	0.2%
5	57	0.2%
6	49	0.2%
9	47	0.2%
7	44	0.2%
Other values (2)	47	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	183932	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	25988	14.1%
e	17072	9.3%
t	13773	7.5%
a	12651	6.9%
r	10893	5.9%
o	10670	5.8%
i	10271	5.6%
s	9045	4.9%
l	7444	4.0%
n	7282	4.0%
Other values (54)	58843	32.0%

None

Value	Count	Frequency (%)
î	1	100.0%

date_reviews
Categorical

Distinct	2060
Distinct (%)	23.7%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

07/01/2016	29
27/12/2015	26
03/12/2015	26
02/01/2016	24
17/12/2015	22
Other values (2055)	8553

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	86800
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	621 ?
Unique (%)	7.2%

Sample

1st row	06/04/2014
2nd row	18/12/2015
3rd row	26/05/2015
4th row	22/07/2013
5th row	14/04/2014

Common Values

Value	Count	Frequency (%)
07/01/2016	29	0.3%
27/12/2015	26	0.3%
03/12/2015	26	0.3%
02/01/2016	24	0.3%
17/12/2015	22	0.3%
04/01/2016	22	0.3%
05/01/2016	22	0.3%
02/12/2015	21	0.2%
29/12/2014	21	0.2%
10/01/2016	21	0.2%
Other values (2050)	8446	97.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
07/01/2016	29	0.3%
03/12/2015	26	0.3%
27/12/2015	26	0.3%
02/01/2016	24	0.3%
17/12/2015	22	0.3%
04/01/2016	22	0.3%
05/01/2016	22	0.3%
28/12/2015	21	0.2%
06/01/2016	21	0.2%
31/12/2015	21	0.2%
Other values (2050)	8446	97.3%

Most occurring characters

Value	Count	Frequency (%)
0	19455	22.4%
1	17375	20.0%
/	17360	20.0%
2	14607	16.8%
5	4553	5.2%
4	3359	3.9%
3	3341	3.8%
6	2171	2.5%
9	1620	1.9%
8	1503	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	69440	80.0%
Other Punctuation	17360	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19455	28.0%
1	17375	25.0%
2	14607	21.0%
5	4553	6.6%
4	3359	4.8%
3	3341	4.8%
6	2171	3.1%
9	1620	2.3%
8	1503	2.2%
7	1456	2.1%

Other Punctuation

Value	Count	Frequency (%)
/	17360	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	86800	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19455	22.4%
1	17375	20.0%
/	17360	20.0%
2	14607	16.8%
5	4553	5.2%
4	3359	3.9%
3	3341	3.8%
6	2171	2.5%
9	1620	1.9%
8	1503	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	19455	22.4%
1	17375	20.0%
/	17360	20.0%
2	14607	16.8%
5	4553	5.2%
4	3359	3.9%
3	3341	3.8%
6	2171	2.5%
9	1620	1.9%
8	1503	1.7%

df_index
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	8680
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5179.6442

Minimum	0
Maximum	9998
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	0
5-th percentile	700.85
Q1	2744.5
median	5299.5
Q3	7668.25
95-th percentile	9520.05
Maximum	9998
Range	9998
Interquartile range (IQR)	4923.75

Descriptive statistics

Standard deviation	2854.7383
Coefficient of variation (CV)	0.55114562
Kurtosis	-1.1973443
Mean	5179.6442
Median Absolute Deviation (MAD)	2452
Skewness	-0.066466685
Sum	44959312
Variance	8149530.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
6846	1	< 0.1%
6860	1	< 0.1%
6859	1	< 0.1%
6858	1	< 0.1%
6857	1	< 0.1%
6856	1	< 0.1%
6855	1	< 0.1%
6854	1	< 0.1%
6853	1	< 0.1%
Other values (8670)	8670	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9998	1	< 0.1%
9997	1	< 0.1%
9995	1	< 0.1%
9994	1	< 0.1%
9993	1	< 0.1%
9992	1	< 0.1%
9991	1	< 0.1%
9990	1	< 0.1%
9988	1	< 0.1%
9987	1	< 0.1%

Item_Weight
Real number (ℝ)

HIGH CORRELATION
MISSING
SKEWED

Distinct	271
Distinct (%)	4.0%
Missing	1826
Missing (%)	21.0%
Infinite	0
Infinite (%)	0.0%
Mean	743.98089

Minimum	5
Maximum	943000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	5
5-th percentile	9
Q1	68
median	200
Q3	488.75
95-th percentile	1600
Maximum	943000
Range	942995
Interquartile range (IQR)	420.75

Descriptive statistics

Standard deviation	12102.097
Coefficient of variation (CV)	16.266677
Kurtosis	5383.7045
Mean	743.98089
Median Absolute Deviation (MAD)	159
Skewness	70.284209
Sum	5099245
Variance	1.4646075 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	463	5.3%
100	273	3.1%
200	187	2.2%
82	178	2.1%
118	171	2.0%
18	167	1.9%
59	164	1.9%
41	157	1.8%
159	142	1.6%
68	136	1.6%
Other values (261)	4816	55.5%
(Missing)	1826	21.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	133	1.5%
9	463	5.3%
14	38	0.4%
18	167	1.9%
23	90	1.0%
27	59	0.7%
32	51	0.6%
36	31	0.4%
41	157	1.8%
45	109	1.3%

Value	Count	Frequency (%)
943000	1	< 0.1%
204000	1	< 0.1%
154000	1	< 0.1%
148000	1	< 0.1%
112000	1	< 0.1%
50000	1	< 0.1%
33000	1	< 0.1%
26000	1	< 0.1%
25000	2	< 0.1%
24000	1	< 0.1%

manufacturer
Categorical

Distinct	2272
Distinct (%)	26.2%
Missing	1
Missing (%)	< 0.1%
Memory size	393.7 KiB

Disney	160
Oxford Diecast	156
Star Wars	114
The Puppet Company	107
Hasbro	105
Other values (2267)	8037

Length

Max length	48
Median length	39
Mean length	10.631409
Min length	1

Characters and Unicode

Total characters	92270
Distinct characters	86
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1312 ?
Unique (%)	15.1%

Sample

1st row	Hornby
2nd row	FunkyBuys
3rd row	ccf
4th row	Hornby
5th row	Hornby

Common Values

Value	Count	Frequency (%)
Disney	160	1.8%
Oxford Diecast	156	1.8%
Star Wars	114	1.3%
The Puppet Company	107	1.2%
Hasbro	105	1.2%
Playmobil	104	1.2%
Mattel	95	1.1%
MyTinyWorld	93	1.1%
Corgi	89	1.0%
Hornby	87	1.0%
Other values (2262)	7569	87.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	329	2.3%
disney	209	1.5%
	198	1.4%
games	187	1.3%
oxford	182	1.3%
diecast	161	1.1%
star	156	1.1%
company	151	1.1%
toys	130	0.9%
wars	115	0.8%
Other values (2605)	12399	87.2%

Most occurring characters

Value	Count	Frequency (%)
e	7215	7.8%
a	7086	7.7%
o	5747	6.2%
r	5637	6.1%
	5538	6.0%
i	5147	5.6%
s	5110	5.5%
n	4337	4.7%
t	4280	4.6%
l	3450	3.7%
Other values (76)	38723	42.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	67313	73.0%
Uppercase Letter	17809	19.3%
Space Separator	5538	6.0%
Dash Punctuation	615	0.7%
Other Punctuation	542	0.6%
Decimal Number	368	0.4%
Open Punctuation	28	< 0.1%
Close Punctuation	28	< 0.1%
Other Symbol	19	< 0.1%
Math Symbol	7	< 0.1%
Other values (2)	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	7215	10.7%
a	7086	10.5%
o	5747	8.5%
r	5637	8.4%
i	5147	7.6%
s	5110	7.6%
n	4337	6.4%
t	4280	6.4%
l	3450	5.1%
y	2431	3.6%
Other values (20)	16873	25.1%

Uppercase Letter

Value	Count	Frequency (%)
T	1690	9.5%
P	1506	8.5%
S	1389	7.8%
C	1355	7.6%
M	1138	6.4%
B	973	5.5%
D	952	5.3%
G	937	5.3%
A	898	5.0%
R	705	4.0%
Other values (16)	6266	35.2%

Decimal Number

Value	Count	Frequency (%)
2	168	45.7%
1	55	14.9%
0	42	11.4%
4	39	10.6%
5	26	7.1%
3	13	3.5%
6	9	2.4%
8	7	1.9%
9	5	1.4%
7	4	1.1%

Other Punctuation

Value	Count	Frequency (%)
&	171	31.5%
.	139	25.6%
'	115	21.2%
!	56	10.3%
,	24	4.4%
/	21	3.9%
:	13	2.4%
?	2	0.4%
"	1	0.2%

Other Symbol

Value	Count	Frequency (%)
®	18	94.7%
°	1	5.3%

Math Symbol

Value	Count	Frequency (%)
+	6	85.7%
\|	1	14.3%

Modifier Symbol

Value	Count	Frequency (%)
^	1	50.0%
`	1	50.0%

Space Separator

Value	Count	Frequency (%)
	5538	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	615	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	28	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	28	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	85122	92.3%
Common	7148	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	7215	8.5%
a	7086	8.3%
o	5747	6.8%
r	5637	6.6%
i	5147	6.0%
s	5110	6.0%
n	4337	5.1%
t	4280	5.0%
l	3450	4.1%
y	2431	2.9%
Other values (46)	34682	40.7%

Common

Value	Count	Frequency (%)
	5538	77.5%
-	615	8.6%
&	171	2.4%
2	168	2.4%
.	139	1.9%
'	115	1.6%
!	56	0.8%
1	55	0.8%
0	42	0.6%
4	39	0.5%
Other values (20)	210	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	92183	99.9%
None	87	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	7215	7.8%
a	7086	7.7%
o	5747	6.2%
r	5637	6.1%
	5538	6.0%
i	5147	5.6%
s	5110	5.5%
n	4337	4.7%
t	4280	4.6%
l	3450	3.7%
Other values (70)	38636	41.9%

None

Value	Count	Frequency (%)
é	63	72.4%
®	18	20.7%
ä	3	3.4%
á	1	1.1%
°	1	1.1%
ê	1	1.1%

MAX_Manufacturer_recommended_age
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	16
Distinct (%)	0.2%
Missing	815
Missing (%)	9.4%
Infinite	0
Infinite (%)	0.0%
Mean	7.0582327

Minimum	3
Maximum	18
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	3
median	5
Q3	12
95-th percentile	15
Maximum	18
Range	15
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	4.5362411
Coefficient of variation (CV)	0.64268795
Kurtosis	-1.0131924
Mean	7.0582327
Median Absolute Deviation (MAD)	2
Skewness	0.69711238
Sum	55513
Variance	20.577483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
3	3177	36.6%
14	998	11.5%
12	616	7.1%
8	549	6.3%
4	478	5.5%
6	473	5.4%
5	419	4.8%
10	398	4.6%
16	253	2.9%
7	252	2.9%
Other values (6)	252	2.9%
(Missing)	815	9.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	3177	36.6%
4	478	5.5%
5	419	4.8%
6	473	5.4%
7	252	2.9%
8	549	6.3%
9	46	0.5%
10	398	4.6%
11	9	0.1%
12	616	7.1%

Value	Count	Frequency (%)
18	63	0.7%
17	8	0.1%
16	253	2.9%
15	84	1.0%
14	998	11.5%
13	42	0.5%
12	616	7.1%
11	9	0.1%
10	398	4.6%
9	46	0.5%

number_in_stock
Real number (ℝ)

Distinct	61
Distinct (%)	0.9%
Missing	2087
Missing (%)	24.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.8493857

Minimum	1
Maximum	92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	10
95-th percentile	26
Maximum	92
Range	91
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	8.2982869
Coefficient of variation (CV)	1.0571893
Kurtosis	8.6460215
Mean	7.8493857
Median Absolute Deviation (MAD)	3
Skewness	2.4731669
Sum	51751
Variance	68.861566
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1159	13.4%
3	874	10.1%
4	680	7.8%
5	530	6.1%
1	433	5.0%
6	414	4.8%
7	331	3.8%
8	271	3.1%
10	188	2.2%
9	187	2.2%
Other values (51)	1526	17.6%
(Missing)	2087	24.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	433	5.0%
2	1159	13.4%
3	874	10.1%
4	680	7.8%
5	530	6.1%
6	414	4.8%
7	331	3.8%
8	271	3.1%
9	187	2.2%
10	188	2.2%

Value	Count	Frequency (%)
92	1	< 0.1%
73	2	< 0.1%
70	1	< 0.1%
62	1	< 0.1%
60	1	< 0.1%
59	1	< 0.1%
58	2	< 0.1%
57	2	< 0.1%
56	4	< 0.1%
54	2	< 0.1%

number_of_answered_questions
Real number (ℝ)

Distinct	19
Distinct (%)	0.2%
Missing	646
Missing (%)	7.4%
Infinite	0
Infinite (%)	0.0%
Mean	1.8457804

Minimum	1
Maximum	39
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	39
Range	38
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.5865793
Coefficient of variation (CV)	1.4013472
Kurtosis	85.765579
Mean	1.8457804
Median Absolute Deviation (MAD)	0
Skewness	7.7699863
Sum	14829
Variance	6.6903924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	5599	64.5%
2	1275	14.7%
3	499	5.7%
4	202	2.3%
5	145	1.7%
6	68	0.8%
11	65	0.7%
9	49	0.6%
7	28	0.3%
13	21	0.2%
Other values (9)	83	1.0%
(Missing)	646	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5599	64.5%
2	1275	14.7%
3	499	5.7%
4	202	2.3%
5	145	1.7%
6	68	0.8%
7	28	0.3%
8	7	0.1%
9	49	0.6%
10	9	0.1%

Value	Count	Frequency (%)
39	13	0.1%
28	4	< 0.1%
23	14	0.2%
19	13	0.1%
17	1	< 0.1%
14	1	< 0.1%
13	21	0.2%
12	21	0.2%
11	65	0.7%
10	9	0.1%

number_of_reviews
Real number (ℝ)

Distinct	183
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.2480415

Minimum	1
Maximum	1399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	6
95-th percentile	36
Maximum	1399
Range	1398
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	34.898772
Coefficient of variation (CV)	3.7736392
Kurtosis	490.36195
Mean	9.2480415
Median Absolute Deviation (MAD)	1
Skewness	17.749078
Sum	80273
Variance	1217.9243
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3716	42.8%
2	1223	14.1%
3	686	7.9%
4	456	5.3%
5	312	3.6%
6	241	2.8%
7	187	2.2%
8	174	2.0%
9	144	1.7%
12	105	1.2%
Other values (173)	1436	16.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3716	42.8%
2	1223	14.1%
3	686	7.9%
4	456	5.3%
5	312	3.6%
6	241	2.8%
7	187	2.2%
8	174	2.0%
9	144	1.7%
10	100	1.2%

Value	Count	Frequency (%)
1399	1	< 0.1%
1040	1	< 0.1%
802	1	< 0.1%
690	1	< 0.1%
649	1	< 0.1%
600	1	< 0.1%
585	1	< 0.1%
561	1	< 0.1%
517	1	< 0.1%
516	1	< 0.1%

price
Real number (ℝ)

SKEWED
ZEROS

Distinct	2416
Distinct (%)	27.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.782684

Minimum	0
Maximum	2439.92
Zeros	1205
Zeros (%)	13.9%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.7
median	8.9
Q3	18.4
95-th percentile	57.65
Maximum	2439.92
Range	2439.92
Interquartile range (IQR)	15.7

Descriptive statistics

Standard deviation	45.554773
Coefficient of variation (CV)	2.561749
Kurtosis	979.23203
Mean	17.782684
Median Absolute Deviation (MAD)	6.95
Skewness	22.259588
Sum	154353.7
Variance	2075.2374
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1205	13.9%
9.99	161	1.9%
4.99	125	1.4%
14.99	118	1.4%
5.99	113	1.3%
7.99	111	1.3%
12.99	111	1.3%
6.99	107	1.2%
3.99	98	1.1%
19.99	94	1.1%
Other values (2406)	6437	74.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1205	13.9%
0.01	1	< 0.1%
0.37	1	< 0.1%
0.39	1	< 0.1%
0.5	1	< 0.1%
0.55	1	< 0.1%
0.6	1	< 0.1%
0.64	1	< 0.1%
0.65	1	< 0.1%
0.7	1	< 0.1%

Value	Count	Frequency (%)
2439.92	1	< 0.1%
995.11	1	< 0.1%
719.95	1	< 0.1%
648.95	1	< 0.1%
629.95	1	< 0.1%
592.95	1	< 0.1%
568.12	1	< 0.1%
538.73	1	< 0.1%
486.95	1	< 0.1%
476.99	1	< 0.1%

product_description
Categorical

Distinct	7863
Distinct (%)	90.6%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

Welcome to k2 we offer combined items postage UK combined items postage discount 100 PH for combined items under 1000 200 350 PH for combined items between 10 to 50 Free PH for the shipment when combined items order over 50	113
Our car models are in scale and true to the original models for adult collectors not toys for children	71
Suitable for the following scales HO Scale	30
Product Description This thirty eight centimetre long glove puppet is great for play or for puppet performances Made of high quality material with excellent attention to details in the construction the animal will be a firm favourite The mouth and paws are movable Children and adults alike are fascinated and enchanted by the magic of puppetry and the mystical puppets from The Puppet Company take the art to a whole new dimension Puppets encourage children to be creative use their imagination to tell exciting stories to bring fairy tales to life to entertain and to have fun The Puppet Company have been producing high quality toys for many years and have built their reputation on their ability to translate any animal or character into a beautifully made and wellfunctioning puppet Box Contains 1 x Long Sleeved Glove Puppet	28
Suitable for the following scales N Scale	25
Other values (7858)	8413

Length

Max length	68104
Median length	1367
Mean length	417.25403
Min length	0

Characters and Unicode

Total characters	3621765
Distinct characters	99
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7627 ?
Unique (%)	87.9%

Sample

1st row	Product Description Hornby 2014 Catalogue Box Contains 1 x one catalogue
2nd row	Size NameLarge FunkyBuys Large Christmas Holiday Express Festive Train Set SITY1017 Toy Light Sounds Battery Operated Smoke
3rd row	BIG CLASSIC TOY TRAIN SET TRACK CARRIAGE LIGHT ENGINE SOUND BOXED KIDS BATTERY Railway Train Set with Light Sound Big Size Curved Track Free Wheeling Action Working Headlight Sound Horn The Track Can Also Be Assembled In More Layouts Length Of Track 104 cm WIDTH OF THE TRACK 68 CM Finely Detailed Realistic Toy Train REQUIRES 2 AA BATTERIES NOT INCLUDED
4th row	Hornby 00 Gauge BR Hawksworth 3rd Class W 2107 W R4410A
5th row	Product Description Hornby RailRoad 040 Gildenlow Salt Co 00 gauge steam locomotive model Safety warning This product is not suitable for children under 3 years because of small parts which could present a choking hazard Some components have functional sharp edges Handle with care Only use this product with the recommended transformer Made in China Box Contains 1x Steam Locomotive Model

Common Values

Value	Count	Frequency (%)
Welcome to k2 we offer combined items postage UK combined items postage discount 100 PH for combined items under 1000 200 350 PH for combined items between 10 to 50 Free PH for the shipment when combined items order over 50	113	1.3%
Our car models are in scale and true to the original models for adult collectors not toys for children	71	0.8%
Suitable for the following scales HO Scale	30	0.3%
Product Description This thirty eight centimetre long glove puppet is great for play or for puppet performances Made of high quality material with excellent attention to details in the construction the animal will be a firm favourite The mouth and paws are movable Children and adults alike are fascinated and enchanted by the magic of puppetry and the mystical puppets from The Puppet Company take the art to a whole new dimension Puppets encourage children to be creative use their imagination to tell exciting stories to bring fairy tales to life to entertain and to have fun The Puppet Company have been producing high quality toys for many years and have built their reputation on their ability to translate any animal or character into a beautifully made and wellfunctioning puppet Box Contains 1 x Long Sleeved Glove Puppet	28	0.3%
Suitable for the following scales N Scale	25	0.3%
9ft long	24	0.3%
Suitable for the following scales OO Scale	22	0.3%
Color and style may vary	14	0.2%
Product Description As one of Amscan Internationals most popular lines you can rest assured the product will be of high quality safe and of innovative design Box Contains One Retail Pack	13	0.1%
Japanese toys	13	0.1%
Other values (7853)	8327	95.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
the	27600	4.5%
and	20466	3.4%
to	12619	2.1%
of	12223	2.0%
a	11842	1.9%
for	8557	1.4%
with	7944	1.3%
in	7870	1.3%
is	7494	1.2%
x	4881	0.8%
Other values (35310)	487649	80.1%

Most occurring characters

Value	Count	Frequency (%)
	607196	16.8%
e	324189	9.0%
a	234909	6.5%
t	226338	6.2%
i	208756	5.8%
o	207781	5.7%
n	189076	5.2%
r	188125	5.2%
s	180735	5.0%
l	135848	3.8%
Other values (89)	1118812	30.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2759943	76.2%
Space Separator	608209	16.8%
Uppercase Letter	186231	5.1%
Decimal Number	66794	1.8%
Connector Punctuation	551	< 0.1%
Other Number	28	< 0.1%
Control	6	< 0.1%
Other Letter	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	324189	11.7%
a	234909	8.5%
t	226338	8.2%
i	208756	7.6%
o	207781	7.5%
n	189076	6.9%
r	188125	6.8%
s	180735	6.5%
l	135848	4.9%
d	112876	4.1%
Other values (35)	751310	27.2%

Uppercase Letter

Value	Count	Frequency (%)
T	18390	9.9%
S	15206	8.2%
C	15034	8.1%
P	14866	8.0%
A	11664	6.3%
D	11230	6.0%
B	10881	5.8%
M	9209	4.9%
I	8443	4.5%
E	7946	4.3%
Other values (26)	63362	34.0%

Decimal Number

Value	Count	Frequency (%)
1	15944	23.9%
0	11636	17.4%
2	8578	12.8%
3	6250	9.4%
5	5562	8.3%
4	5375	8.0%
6	3939	5.9%
8	3492	5.2%
9	3206	4.8%
7	2812	4.2%

Other Number

Value	Count	Frequency (%)
½	24	85.7%
¼	2	7.1%
¾	2	7.1%

Space Separator

Value	Count	Frequency (%)
	607196	99.8%
	1013	0.2%

Connector Punctuation

Value	Count	Frequency (%)
_	551	100.0%

Control

Value	Count	Frequency (%)
	6	100.0%

Other Letter

Value	Count	Frequency (%)
º	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2946177	81.3%
Common	675588	18.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	324189	11.0%
a	234909	8.0%
t	226338	7.7%
i	208756	7.1%
o	207781	7.1%
n	189076	6.4%
r	188125	6.4%
s	180735	6.1%
l	135848	4.6%
d	112876	3.8%
Other values (72)	937544	31.8%

Common

Value	Count	Frequency (%)
	607196	89.9%
1	15944	2.4%
0	11636	1.7%
2	8578	1.3%
3	6250	0.9%
5	5562	0.8%
4	5375	0.8%
6	3939	0.6%
8	3492	0.5%
9	3206	0.5%
Other values (7)	4410	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3620349	> 99.9%
None	1416	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	607196	16.8%
e	324189	9.0%
a	234909	6.5%
t	226338	6.3%
i	208756	5.8%
o	207781	5.7%
n	189076	5.2%
r	188125	5.2%
s	180735	5.0%
l	135848	3.8%
Other values (54)	1117396	30.9%

None

Value	Count	Frequency (%)
	1013	71.5%
é	171	12.1%
â	27	1.9%
ü	26	1.8%
½	24	1.7%
Ã	19	1.3%
è	17	1.2%
ö	16	1.1%
ä	15	1.1%
ê	13	0.9%
Other values (25)	75	5.3%

Product_Dimensions_X
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	628
Distinct (%)	9.4%
Missing	2015
Missing (%)	23.2%
Infinite	0
Infinite (%)	0.0%
Mean	24.075109

Minimum	0.1
Maximum	818
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	0.1
5-th percentile	3.8
Q1	11.8
median	19.7
Q3	30
95-th percentile	52.1
Maximum	818
Range	817.9
Interquartile range (IQR)	18.2

Descriptive statistics

Standard deviation	28.117883
Coefficient of variation (CV)	1.1679234
Kurtosis	270.08094
Mean	24.075109
Median Absolute Deviation (MAD)	9
Skewness	12.437066
Sum	160460.6
Variance	790.61532
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.2	137	1.6%
30	105	1.2%
19	100	1.2%
25.4	92	1.1%
14	90	1.0%
10	88	1.0%
7.6	86	1.0%
20.3	79	0.9%
10.2	76	0.9%
17.8	76	0.9%
Other values (618)	5736	66.1%
(Missing)	2015	23.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	17	0.2%
0.2	7	0.1%
0.3	5	0.1%
0.4	3	< 0.1%
0.5	9	0.1%
0.6	4	< 0.1%
0.7	1	< 0.1%
0.8	6	0.1%
0.9	1	< 0.1%
1	26	0.3%

Value	Count	Frequency (%)
818	1	< 0.1%
750	2	< 0.1%
500	1	< 0.1%
470	1	< 0.1%
405	1	< 0.1%
365.8	1	< 0.1%
350	1	< 0.1%
325	1	< 0.1%
305	1	< 0.1%
290	1	< 0.1%

Product_Dimensions_Y
Real number (ℝ)

HIGH CORRELATION
MISSING
SKEWED

Distinct	466
Distinct (%)	7.0%
Missing	2015
Missing (%)	23.2%
Infinite	0
Infinite (%)	0.0%
Mean	16.244036

Minimum	0.1
Maximum	5148.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	0.1
5-th percentile	2.5
Q1	7
median	12.5
Q3	20
95-th percentile	34.46
Maximum	5148.6
Range	5148.5
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	64.679551
Coefficient of variation (CV)	3.9817414
Kurtosis	5951.7509
Mean	16.244036
Median Absolute Deviation (MAD)	6.3
Skewness	75.056084
Sum	108266.5
Variance	4183.4443
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.2	174	2.0%
7.6	167	1.9%
15.2	144	1.7%
5.1	127	1.5%
2.5	113	1.3%
14	112	1.3%
3.8	109	1.3%
12.7	105	1.2%
12	97	1.1%
6.4	97	1.1%
Other values (456)	5420	62.4%
(Missing)	2015	23.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	30	0.3%
0.2	10	0.1%
0.3	14	0.2%
0.4	1	< 0.1%
0.5	26	0.3%
0.6	7	0.1%
0.7	1	< 0.1%
0.8	5	0.1%
0.9	3	< 0.1%
1	47	0.5%

Value	Count	Frequency (%)
5148.6	1	< 0.1%
190	1	< 0.1%
183	2	< 0.1%
182	1	< 0.1%
180.3	2	< 0.1%
180	1	< 0.1%
178	1	< 0.1%
168	1	< 0.1%
160	2	< 0.1%
157.5	1	< 0.1%

Product_Dimensions_Z
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	430
Distinct (%)	6.5%
Missing	2051
Missing (%)	23.6%
Infinite	0
Infinite (%)	0.0%
Mean	11.951169

Minimum	0.1
Maximum	290
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.7 KiB

Quantile statistics

Minimum	0.1
5-th percentile	1
Q1	3.8
median	7.2
Q3	15.2
95-th percentile	37
Maximum	290
Range	289.9
Interquartile range (IQR)	11.4

Descriptive statistics

Standard deviation	14.832364
Coefficient of variation (CV)	1.2410806
Kurtosis	60.213364
Mean	11.951169
Median Absolute Deviation (MAD)	4.5
Skewness	5.3672254
Sum	79224.3
Variance	219.99903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.1	152	1.8%
3.8	131	1.5%
3	129	1.5%
2	128	1.5%
4	122	1.4%
7.6	120	1.4%
5	117	1.3%
6	113	1.3%
2.5	106	1.2%
1	101	1.2%
Other values (420)	5410	62.3%
(Missing)	2051	23.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	28	0.3%
0.2	42	0.5%
0.3	38	0.4%
0.4	30	0.3%
0.5	56	0.6%
0.6	56	0.6%
0.7	2	< 0.1%
0.8	50	0.6%
0.9	2	< 0.1%
1	101	1.2%

Value	Count	Frequency (%)
290	1	< 0.1%
280	1	< 0.1%
220	1	< 0.1%
211	1	< 0.1%
182.9	2	< 0.1%
174	1	< 0.1%
128	1	< 0.1%
122.5	1	< 0.1%
121.9	1	< 0.1%
120	1	< 0.1%

product_name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	8650
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

Zoo Animal Hand Sock Glove Finger Puppets Sack Plush Toy Cow	3
INTEX Inflatable Swimming Paddling Play Pool 3 Ring Blue Toy Kids Childs Childrens Baby Family Sizes - 45'' , 58'' , 66'' Diameter (58'' x 13'')	2
Optimus Prime DMK 01 Transformers Movie Dual Model Kit	2
Happy 6th Birthday Giant Party Wall Banner 3 Banners Age 6 Party Decoration	2
Crayola - 9 Glitter Glue	2
Other values (8645)	8669

Length

Max length	536
Median length	182
Mean length	54.040092
Min length	3

Characters and Unicode

Total characters	469068
Distinct characters	122
Distinct categories	18 ?
Distinct scripts	2 ?
Distinct blocks	6 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8621 ?
Unique (%)	99.3%

Sample

1st row	Hornby 2014 Catalogue
2nd row	FunkyBuys® Large Christmas Holiday Express Festive Train Set (SI-TY1017) Toy Light / Sounds / Battery Operated & Smoke
3rd row	CLASSIC TOY TRAIN SET TRACK CARRIAGES LIGHT ENGINE BOXED BOYS KIDS BATTERY
4th row	HORNBY Coach R4410A BR Hawksworth Corridor 3rd
5th row	Hornby 00 Gauge 0-4-0 Gildenlow Salt Co. Steam Locomotive Model

Common Values

Value	Count	Frequency (%)
Zoo Animal Hand Sock Glove Finger Puppets Sack Plush Toy Cow	3	< 0.1%
INTEX Inflatable Swimming Paddling Play Pool 3 Ring Blue Toy Kids Childs Childrens Baby Family Sizes - 45'' , 58'' , 66'' Diameter (58'' x 13'')	2	< 0.1%
Optimus Prime DMK 01 Transformers Movie Dual Model Kit	2	< 0.1%
Happy 6th Birthday Giant Party Wall Banner 3 Banners Age 6 Party Decoration	2	< 0.1%
Crayola - 9 Glitter Glue	2	< 0.1%
100 six sided dice, 14mm, random colours	2	< 0.1%
Playmobil 6678 Large Floating Pirate Raiders' Ship with 3 Pirates	2	< 0.1%
XT-XINTE FQ777-124 Pocket Drone 4CH 6Axis Gyro UFO Quadcopter With Switchable Controller RTF Helicopter (Black)	2	< 0.1%
Melissa & Doug Princess Puppet	2	< 0.1%
The Trash Pack Sewer Truck	2	< 0.1%
Other values (8640)	8659	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	3656	4.7%
the	786	1.0%
of	686	0.9%
set	653	0.8%
and	625	0.8%
pack	544	0.7%
with	542	0.7%
scale	535	0.7%
model	526	0.7%
figure	519	0.7%
Other values (13662)	68193	88.3%

Most occurring characters

Value	Count	Frequency (%)
	68582	14.6%
e	34353	7.3%
a	28059	6.0%
r	23481	5.0%
i	22977	4.9%
o	22227	4.7%
t	19222	4.1%
n	18639	4.0%
l	17262	3.7%
s	16801	3.6%
Other values (112)	197465	42.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	284472	60.6%
Uppercase Letter	79346	16.9%
Space Separator	68586	14.6%
Decimal Number	22781	4.9%
Other Punctuation	6136	1.3%
Dash Punctuation	4234	0.9%
Open Punctuation	1586	0.3%
Close Punctuation	1579	0.3%
Math Symbol	235	0.1%
Other Symbol	94	< 0.1%
Other values (8)	19	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	34353	12.1%
a	28059	9.9%
r	23481	8.3%
i	22977	8.1%
o	22227	7.8%
t	19222	6.8%
n	18639	6.6%
l	17262	6.1%
s	16801	5.9%
c	10515	3.7%
Other values (24)	70936	24.9%

Uppercase Letter

Value	Count	Frequency (%)
S	7476	9.4%
C	6403	8.1%
P	6080	7.7%
T	5605	7.1%
B	5081	6.4%
M	4805	6.1%
D	4410	5.6%
A	4397	5.5%
R	3968	5.0%
F	3549	4.5%
Other values (18)	27572	34.7%

Other Punctuation

Value	Count	Frequency (%)
,	1252	20.4%
.	1052	17.1%
:	1028	16.8%
/	775	12.6%
&	580	9.5%
"	575	9.4%
'	471	7.7%
!	198	3.2%
#	103	1.7%
*	70	1.1%
Other values (5)	32	0.5%

Decimal Number

Value	Count	Frequency (%)
1	4647	20.4%
0	4357	19.1%
2	3004	13.2%
3	2093	9.2%
5	1914	8.4%
4	1864	8.2%
6	1567	6.9%
7	1260	5.5%
8	1157	5.1%
9	918	4.0%

Other Symbol

Value	Count	Frequency (%)
®	65	69.1%
✮	16	17.0%
★	5	5.3%
°	3	3.2%
♥	2	2.1%
☥	1	1.1%
�	1	1.1%
©	1	1.1%

Math Symbol

Value	Count	Frequency (%)
+	181	77.0%
~	34	14.5%
\|	14	6.0%
=	4	1.7%
>	1	0.4%
×	1	0.4%

Close Punctuation

Value	Count	Frequency (%)
)	1457	92.3%
]	111	7.0%
}	10	0.6%
）	1	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	1465	92.4%
[	111	7.0%
{	10	0.6%

Currency Symbol

Value	Count	Frequency (%)
£	2	50.0%
$	1	25.0%
¢	1	25.0%

Space Separator

Value	Count	Frequency (%)
	68582	> 99.9%
	4	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
`	5	83.3%
¨	1	16.7%

Dash Punctuation

Value	Count	Frequency (%)
-	4234	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	4	100.0%

Initial Punctuation

Value	Count	Frequency (%)
«	1	100.0%

Final Punctuation

Value	Count	Frequency (%)
»	1	100.0%

Format

Value	Count	Frequency (%)
	1	100.0%

Other Letter

Value	Count	Frequency (%)
ª	1	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	363819	77.6%
Common	105249	22.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	34353	9.4%
a	28059	7.7%
r	23481	6.5%
i	22977	6.3%
o	22227	6.1%
t	19222	5.3%
n	18639	5.1%
l	17262	4.7%
s	16801	4.6%
c	10515	2.9%
Other values (53)	150283	41.3%

Common

Value	Count	Frequency (%)
	68582	65.2%
1	4647	4.4%
0	4357	4.1%
-	4234	4.0%
2	3004	2.9%
3	2093	2.0%
5	1914	1.8%
4	1864	1.8%
6	1567	1.5%
(	1465	1.4%
Other values (49)	11522	10.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	468912	> 99.9%
None	130	< 0.1%
Dingbats	16	< 0.1%
Misc Symbols	8	< 0.1%
Specials	1	< 0.1%
Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	68582	14.6%
e	34353	7.3%
a	28059	6.0%
r	23481	5.0%
i	22977	4.9%
o	22227	4.7%
t	19222	4.1%
n	18639	4.0%
l	17262	3.7%
s	16801	3.6%
Other values (81)	197309	42.1%

None

Value	Count	Frequency (%)
®	65	50.0%
ß	10	7.7%
é	10	7.7%
ü	9	6.9%
ä	6	4.6%
ö	4	3.1%
	4	3.1%
°	3	2.3%
à	2	1.5%
£	2	1.5%
Other values (15)	15	11.5%

Dingbats

Value	Count	Frequency (%)
✮	16	100.0%

Misc Symbols

Value	Count	Frequency (%)
★	5	62.5%
♥	2	25.0%
☥	1	12.5%

Specials

Value	Count	Frequency (%)
�	1	100.0%

Punctuation

Value	Count	Frequency (%)
″	1	100.0%

sub_category
Categorical

Distinct	231
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Memory size	393.7 KiB

Vehicles	856
Toys	582
Science Fiction & Fantasy	467
Bead Art & Jewellery-Making	344
Dice & Dice Games	273
Other values (226)	6158

Length

Max length	36
Median length	27
Mean length	12.945046
Min length	3

Characters and Unicode

Total characters	112363
Distinct characters	56
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	77 ?
Unique (%)	0.9%

Sample

1st row	Trains
2nd row	Trains
3rd row	Trains
4th row	Trains
5th row	Trains

Common Values

Value	Count	Frequency (%)
Vehicles	856	9.9%
Toys	582	6.7%
Science Fiction & Fantasy	467	5.4%
Bead Art & Jewellery-Making	344	4.0%
Dice & Dice Games	273	3.1%
Packs & Sets	251	2.9%
Banners	248	2.9%
Hand Puppets	235	2.7%
Card Games	232	2.7%
Balloons	223	2.6%
Other values (221)	4969	57.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	2843	15.4%
vehicles	859	4.6%
games	792	4.3%
toys	769	4.2%
accessories	612	3.3%
dice	546	3.0%
science	467	2.5%
fiction	467	2.5%
fantasy	467	2.5%
sets	428	2.3%
Other values (313)	10237	55.4%

Most occurring characters

Value	Count	Frequency (%)
s	11927	10.6%
e	10841	9.6%
	9807	8.7%
a	7585	6.8%
i	7183	6.4%
o	5966	5.3%
c	5474	4.9%
r	5161	4.6%
n	5027	4.5%
t	5010	4.5%
Other values (46)	38382	34.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	82973	73.8%
Uppercase Letter	16047	14.3%
Space Separator	9807	8.7%
Other Punctuation	3097	2.8%
Dash Punctuation	395	0.4%
Decimal Number	44	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	11927	14.4%
e	10841	13.1%
a	7585	9.1%
i	7183	8.7%
o	5966	7.2%
c	5474	6.6%
r	5161	6.2%
n	5027	6.1%
t	5010	6.0%
l	4685	5.6%
Other values (16)	14114	17.0%

Uppercase Letter

Value	Count	Frequency (%)
T	2225	13.9%
S	1717	10.7%
P	1403	8.7%
F	1303	8.1%
A	1263	7.9%
C	1149	7.2%
D	1146	7.1%
B	1126	7.0%
V	890	5.5%
G	863	5.4%
Other values (13)	2962	18.5%

Other Punctuation

Value	Count	Frequency (%)
&	2843	91.8%
'	213	6.9%
,	41	1.3%

Decimal Number

Value	Count	Frequency (%)
3	43	97.7%
4	1	2.3%

Space Separator

Value	Count	Frequency (%)
	9807	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	395	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	99020	88.1%
Common	13343	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	11927	12.0%
e	10841	10.9%
a	7585	7.7%
i	7183	7.3%
o	5966	6.0%
c	5474	5.5%
r	5161	5.2%
n	5027	5.1%
t	5010	5.1%
l	4685	4.7%
Other values (39)	30161	30.5%

Common

Value	Count	Frequency (%)
	9807	73.5%
&	2843	21.3%
-	395	3.0%
'	213	1.6%
3	43	0.3%
,	41	0.3%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	112363	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	11927	10.6%
e	10841	9.6%
	9807	8.7%
a	7585	6.8%
i	7183	6.4%
o	5966	5.3%
c	5474	4.9%
r	5161	4.6%
n	5027	4.5%
t	5010	4.5%
Other values (46)	38382	34.2%

type_product
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	2087
Missing (%)	24.0%
Memory size	393.7 KiB

new	6452
used	128
collectible	11
refurbished	2

Length

Max length	11
Median length	3
Mean length	3.0351888
Min length	3

Characters and Unicode

Total characters	20011
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	new
2nd row	new
3rd row	new
4th row	new
5th row	new

Common Values

Value	Count	Frequency (%)
new	6452	74.3%
used	128	1.5%
collectible	11	0.1%
refurbished	2	< 0.1%
(Missing)	2087	24.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
new	6452	97.9%
used	128	1.9%
collectible	11	0.2%
refurbished	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	6606	33.0%
n	6452	32.2%
w	6452	32.2%
u	130	0.6%
s	130	0.6%
d	130	0.6%
l	33	0.2%
c	22	0.1%
i	13	0.1%
b	13	0.1%
Other values (5)	30	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20011	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	6606	33.0%
n	6452	32.2%
w	6452	32.2%
u	130	0.6%
s	130	0.6%
d	130	0.6%
l	33	0.2%
c	22	0.1%
i	13	0.1%
b	13	0.1%
Other values (5)	30	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20011	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	6606	33.0%
n	6452	32.2%
w	6452	32.2%
u	130	0.6%
s	130	0.6%
d	130	0.6%
l	33	0.2%
c	22	0.1%
i	13	0.1%
b	13	0.1%
Other values (5)	30	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20011	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	6606	33.0%
n	6452	32.2%
w	6452	32.2%
u	130	0.6%
s	130	0.6%
d	130	0.6%
l	33	0.2%
c	22	0.1%
i	13	0.1%
b	13	0.1%
Other values (5)	30	0.1%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	df_index	product_name	manufacturer	price	number_of_reviews	number_of_answered_questions	average_review_rating	product_description	customer_questions_and_answers	customer_reviews	sub_category	category	type_product	number_in_stock	customer_review	date_reviews	Item_Weight	Product_Dimensions_X	Product_Dimensions_Y	Product_Dimensions_Z	MAX_Manufacturer_recommended_age
0	0	Hornby 2014 Catalogue	Hornby	3.42	15.0	1.0	4.9	Product Description Hornby 2014 Catalogue Box Contains 1 x one catalogue	Does this catalogue detail all the previous Hornby products please HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent years\n \n see more\n \n \n \n HiThe 2014 catalogue does indeed detail previous models but also includes new releases for 2014You would be advised to purchase models as you need them to avoid them being discontinued in subsequent yearsHope this helps\n \n see less	Worth Buying For The Pictures Alone As Ever	Trains	Hobbies	new	5.0	4.0	06/04/2014	640.0	29.6	20.8	1.0	6.0
1	1	FunkyBuys® Large Christmas Holiday Express Festive Train Set (SI-TY1017) Toy Light / Sounds / Battery Operated & Smoke	FunkyBuys	16.99	2.0	1.0	4.5	Size NameLarge FunkyBuys Large Christmas Holiday Express Festive Train Set SITY1017 Toy Light Sounds Battery Operated Smoke	can you turn off sounds hi no you cant turn sound off	Four Stars	Trains	Hobbies	NaN	NaN	4.0	18/12/2015	NaN	NaN	NaN	NaN	3.0
2	2	CLASSIC TOY TRAIN SET TRACK CARRIAGES LIGHT ENGINE BOXED BOYS KIDS BATTERY	ccf	9.99	17.0	2.0	3.9	BIG CLASSIC TOY TRAIN SET TRACK CARRIAGE LIGHT ENGINE SOUND BOXED KIDS BATTERY Railway Train Set with Light Sound Big Size Curved Track Free Wheeling Action Working Headlight Sound Horn The Track Can Also Be Assembled In More Layouts Length Of Track 104 cm WIDTH OF THE TRACK 68 CM Finely Detailed Realistic Toy Train REQUIRES 2 AA BATTERIES NOT INCLUDED	What is the gauge of the track Hi PaulTruthfully Im not sure But its very much alike to a 00 gauge But this train set isnt an addon for an electric train set nor has nothing to do with oneI bought this for my 4 year old nephew as he adores trains but is far too young for an electric set He was VERY happy with this though what is the layout of the tracks Its an oval shape layout	Highly Recommended	Trains	Hobbies	new	2.0	5.0	26/05/2015	NaN	NaN	NaN	NaN	3.0
3	3	HORNBY Coach R4410A BR Hawksworth Corridor 3rd	Hornby	39.99	1.0	2.0	5.0	Hornby 00 Gauge BR Hawksworth 3rd Class W 2107 W R4410A	nan	I love it	Trains	Hobbies	NaN	NaN	5.0	22/07/2013	259.0	31.6	9.2	4.6	3.0
4	4	Hornby 00 Gauge 0-4-0 Gildenlow Salt Co. Steam Locomotive Model	Hornby	32.19	3.0	2.0	4.7	Product Description Hornby RailRoad 040 Gildenlow Salt Co 00 gauge steam locomotive model Safety warning This product is not suitable for children under 3 years because of small parts which could present a choking hazard Some components have functional sharp edges Handle with care Only use this product with the recommended transformer Made in China Box Contains 1x Steam Locomotive Model	nan	Birthday present	Trains	Hobbies	NaN	NaN	5.0	14/04/2014	159.0	18.4	10.2	6.0	4.0
5	5	20pcs Model Garden Light Double Heads Lamppost Scale 1:100	Generic	6.99	2.0	1.0	5.0	These delicate model garden lights are mainly used in teaching photography and various kinds of scene model Each of them is completed with wires and has double heads which can be lighten with 6V power These model lights measure about 7cm high Light up your model layout with this great model lamppost Description A pack of 20pcs model garden lamps Each has double head completed with wires and bulbs Mainly used to decorate your model layout Voltage 6V Power 1 W Height Approx 276 inch 7cm Scale 1100 Material Plastic Main Color Black Note Each lamp has 4 wires altogether When you connect these wires with the power please connect two long wires with one end and connect the rest two short wires with another end Package Include 20pcs model garden lights	is it possible to replace thr grain of wheat lamps with leds Hi Pete No its not possible the main pole is to thin to take readily available LEDs wiring I was hoping to do this myself but it would mean rewireing the LEDs with thin enough wire that I have not managed to track down yet I will be trying by using the existing wire Tricky job cutting the tops off the lantern and \n \n see more\n \n \n \n Hi Pete No its not possible the main pole is to thin to take readily available LEDs wiring I was hoping to do this myself but it would mean rewireing the LEDs with thin enough wire that I have not managed to track down yet I will be trying by using the existing wire Tricky job cutting the tops off the lantern and hoping I can pull enough wire through to solder the led back on That I will be trying in the next few months Hope I may have been some help good luck Derryck\n \n see less	Five Stars	Lamps & Lighting	Hobbies	NaN	NaN	5.0	27/12/2014	NaN	NaN	NaN	NaN	3.0
6	6	Hornby 00 Gauge 230mm BR Bogie Passenger Brake Coach Model (Red)	Hornby	24.99	2.0	1.0	4.5	Product Description Hornby BR bogie passenger brake coach has pristine finish Livery BR red livery Entered Service 1930 Period 1950 230mm coach model length The truly fascinating and varied range of Hornby coaches offers something for most enthusiasts modelling the various regions and periods of the British rail network Box Contains 1x Red Bogie Passenger Brake	nan	High standard model well worth the wait Replaces	Trains	Hobbies	NaN	NaN	5.0	03/10/2014	222.0	31.0	9.2	4.6	3.0
7	7	Hornby Santa's Express Train Set	Hornby	69.93	36.0	7.0	4.3	Product Description Inject a bit of Hornby magic into Christmas with the special Santas Express Train Set The set includes everything you need to get started including Santas festive train an oval track power transformer and mat Whether this is your first train set or youre a seasoned modeller Santas Express will delight young and old alike and is sure to become a festive favourite for a spectacular Christmas decoration build the set around the base of your Christmas tree or use as a moving table centre add some Christmas cheer to your existing model railwaySantas special train includes his very own steam engine a wagon full of presents and a closed van in which he keeps his reindeer The spritely little engine in its colourful livery is more than capable of pulling such an important train around the oval of track included in this set Additional track packs can be obtained to make the layout larger and even more exciting and there is even a Hornby MidiMat included so you can see how Santas Special train set can grow and grow into a truly exciting model railway Contents Santas Express 040 locomotive 7 Plank Open Wagon with lots of presents Reindeer Box Van 3rd Radius Starter Oval Power Track and Track Straight R8250 Train Controller P9000 Transformer Hornby MidiMat 1600 x 1180mm This item will be supplied with a UK transformer Box Contains 1x Santas Express 040 locomotive 7x Plank Open Wagon 1x Reindeer Box Van 1x 3rd Radius Starter Oval 1x Power Track and Track Straight 1xR8250 Train Controller 1x P9000 Transformer 1x Hornby MidiMat 1600 x 1180mm	Can this train go backwards as well as forward Yes Variable speed in both directions Is this train set OO Gauge Yes it is can it sit directly on carpet or will i need a board to put it on The train set can be run on carpet although a board is more beneficial Hi does this play Christmas sound effects thanks Hi no sound effects is the carriages and engine hard plastic Yes they are It is a lovely piece kids loved it the grown ups even more How long is the track Its about 4 feet long each side Then theres the 2 bends one each end How long is the Santa express train and its carriages in total from engine to end of last carriage Thanks 12 inches long	Beautiful set	Trains	Hobbies	new	3.0	5.0	03/12/2015	1200.0	40.0	29.8	8.0	8.0
8	8	Hornby Gauge Western Express Digital Train Set with eLink and TTS Loco Train Set	Hornby	235.58	1.0	1.0	5.0	Western Express Digital Train Set with eLink and TTS sound loco Set Hornby R1184	The description is incorrect the hornby site provides the following contents gwr ketley hall hall class 460 locomotive correct Another Seller has entered the wrong description you are right it is the Ketley Hall locomotive	Five Stars	Trains	Hobbies	new	4.0	5.0	23/12/2015	2300.0	80.4	24.0	8.2	8.0
9	9	Learning Curve Chuggington Interactive Chatsworth	Chuggington	0.00	8.0	1.0	4.8	Product Description An amazingly Interactive Chuggington World Chuggington Interactive Chatsworth instantly recognises and magically talks to any other engine training stop and set accessories This engine has over 60 sounds and phrases when used with other Chuggington interactive products Featuring the actual voice from the Chuggington show Each Interactive talking engine features Smart Talk technology which enables them to instantly recognise any other engine react to any train stop and respond to your play Chuggington Interactive is a magical open ended play system featuring iconic destinations and characters from the BBCs CBeebies top rated preschool show Chuggington Chatsworth is a very proper engine who lives next door to Harrison in the upper level of the roundhouse Chatsworth is honest good mannered polite and considerate of others however he considers himself as the upper crust of Chuggington On time clean and in fine repair Chatsworth always presents his best wheel forward as first impressions are very important to him Engines recognise and magically talk to each other training stops and set accessories Requires 2 x AA batteries included Box Contains 1 x Interactive Chatsworth engine	nan	Chuggers are go	Trains	Hobbies	new	1.0	4.0	11/01/2011	150.0	12.7	4.4	6.7	NaN

	df_index	product_name	manufacturer	price	number_of_reviews	number_of_answered_questions	average_review_rating	product_description	customer_questions_and_answers	customer_reviews	sub_category	category	type_product	number_in_stock	customer_review	date_reviews	Item_Weight	Product_Dimensions_X	Product_Dimensions_Y	Product_Dimensions_Z	MAX_Manufacturer_recommended_age
9987	9987	Thundercats 10cm Action Figure: Wilykat	Thundercats	11.44	3.0	3.0	4.7	ThunderCats WilyKat 4 Action Figure Toy	nan	A reboot of Thundercats for a new generation	Collectible Props & Memorabilia	Hobbies	new	3.0	5.0	17/07/2012	68.0	3.8	14.0	21.0	4.0
9988	9988	Captain America - The First Avenger - Movie Series - Red Skull - Action Figure 08 - 31688	Captain america	25.33	2.0	3.0	4.0	Captain America The First Avenger Movie Series Red Skull Action Figure 08 31688 RED SKULL is an evil genius with an endless hunger for power He wants nothing more than to see CAPTAIN AMERICA destroyed He creates even more devastating weapons by harnessing the might of the Cosmic Cube Now armed with an explosive rocket launcher RED SKULL is ready to make another attempt at world domination Imagine devastating battles with your RED SKULL figure CAPTAIN AMERICA sold separately will never stop in his quest for justice and truth but RED SKULL wont stop in his quest for power Who will win when these two collide Only you can decide Captain America The First Avenger movie 375 inch action figure from Hasbro Red Skull figure 08 comes with rocket launcher accessories Collect them all For Ages 4 Up	nan	The Red Skull A Good Figure of a Very Bad Guy	Collectible Props & Memorabilia	Hobbies	new	7.0	4.0	27/07/2011	64.0	21.6	15.2	5.1	4.0
9990	9990	Iron Maiden 8-Inch Eddie 2 Mintutes To Midnight Clothed Figure (Black)	IronMan	29.79	1.0	3.0	5.0	Product Description Straight from the cover of Iron Maidens 1984 single 2 Minutes to Midnight Eddie is dressed in tailored fabric clothing similar to the toy lines that helped define the licensed action figure market in the 1970s The bands legendary mascot stands 8 tall and features interchangeable right hands and assault rifle accessory Comes in blister card packaging with resealable protective clamshell Safety Warning not appropriate for children under the age of 3 See all Product Description	nan	up the irons this is amazing figure to have as Im a iron maiden fan	Collectible Props & Memorabilia	Hobbies	new	16.0	5.0	19/03/2016	181.0	3.8	7.6	20.3	18.0
9991	9991	Power Rangers Dino Charge 30 cm Blue Ranger Figure	Power Rangers	9.75	7.0	3.0	4.1	Product Description The Power Rangers Dino Charge Rangers are bigger and better than ever on a 30cm Figure scale With their Charged Up size the Power Rangers are armed with 1 battle gear item to defend the earth from villains Evil doesnt stand a chance Ages 4 Box Contains 1 x Figure 1 x Battle Gear Item	nan	with sounds this one didnt so I was slightly disappointed but my 3 year old loves it	Collectible Props & Memorabilia	Hobbies	new	6.0	4.0	01/01/2016	168.0	5.0	10.5	30.0	10.0
9992	9992	Star Wars The Clone Wars CW01 Captain Rex 3.75" Action Figure (98349)	Star Wars	32.99	2.0	3.0	5.0	Play the Galactic Battle Game with your favorite Star Wars Heroes and Villains Will you use the Force Battle SKills or your Luck to win Dueling card battle base and game die inside Each figure has a unique card Collect them all	nan	brilliant sculpt	Toys	Characters & Brands	new	2.0	5.0	13/09/2010	68.0	22.6	14.5	5.8	4.0
9993	9993	Playskool Heroes Super Hero Repulsor Drill Vehicle With Iron Man Figure	Super Heroes	9.99	2.0	3.0	4.0	IRON MAN needs a drill thats as tough as he is His rolling REPULSOR DRILL is built from the same advanced technology that powers his unstoppable IRON MAN suit The REPULSOR DRILL vehicle is just what your IRON MAN figure needs to be an even bigger threat to evil Your figure can stand at the controls as you roll the vehicle toward the next obstacle and then when the moment comes to power through it turn on the spinning drill Vehicle comes with figure Suitable for ages 3 years Safety Information Warning Not suitable for Children under 3 years	nan	cool little toy	Collectible Props & Memorabilia	Hobbies	new	5.0	5.0	11/11/2014	281.0	28.0	8.8	8.0	NaN
9994	9994	Factory Entertainment Green Hornet Movie: Kato Action Figure	Green Hornet	9.50	1.0	3.0	4.0	6 inch action figure featuring the Kato chracter from the Green Hornet mnovie	nan	kato	Collectible Props & Memorabilia	Hobbies	NaN	NaN	4.0	16/06/2014	204.0	17.8	7.6	7.6	12.0
9995	9995	Batman 1966 TV Series Action Figures - The Riddler	Mattel	22.95	3.0	3.0	5.0	DC 66 Batman Classic TV Series 6 Inch Riddler Action Figure	nan	Realistic	Collectible Props & Memorabilia	Hobbies	new	5.0	5.0	31/03/2014	136.0	19.0	5.1	30.5	12.0
9997	9997	Defiance Lawkeeper Metal Badge Prop Replica	Olde Scotland Yard Ltd.	43.99	1.0	3.0	5.0	Includes 1x Badge with holder and chain High quality metal construction Ball clasp necklace Removable from holster features heavy duty pin design Brand new	nan	Five Stars	Buttons & Pins	Novelty & Special Use	new	3.0	5.0	18/12/2015	159.0	7.6	7.6	2.5	14.0
9998	9998	Justice League of America Series 3 Green Lantern Action Figure	DC Comics	49.81	1.0	3.0	5.0	Designed by Ed BenesIts here the third series based on the popular DC Comics series JUSTICE LEAGUE OF AMERICA written by New York Times bestselling author Brad Meltzer and illustrated by Ed Benes Green Lantern Wonder Woman The Flash and GeoForce are the latest JLA heroes to be made into action figures Green Lantern 675 HEach figure features multiple points of articulation and a base 4color blister card packaging	nan	The best sculpt in a while	Collectible Props & Memorabilia	Hobbies	new	3.0	5.0	13/05/2010	181.0	21.6	15.2	34.3	14.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Control

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common